﻿CREATE PROCEDURE [dbo].[yaf_usergroup_list](
                @UserID INT)
AS
    BEGIN
        SELECT   b.GroupID,
                 b.Name
        FROM     yaf_UserGroup a
                 JOIN yaf_Group b
                   ON b.GroupID = a.GroupID
        WHERE    a.UserID = @UserID
        ORDER BY b.Name
    END


